var express = require('express');
var path = require('path');
var favicon = require('serve-favicon');
var logger = require('morgan');
var cookieParser = require('cookie-parser');
var bodyParser = require('body-parser');
var mysql = require('mysql');
var moment = require('moment');

var log4js = require('./config/log4js');

var index = require('./routes/index');

var app = express();

var dbPool;

// 初始化db
exports.getDB = function () {

    if (dbPool != null) return dbPool;
    dbPool = mysql.createPool({
        host     : '123.56.221.27',
        user     : 'root',
        password : '745764370HExu..',
        database : 'reptile'
    });
    return dbPool;
}

// log4js
app.use(log4js.express);

// view engine setup
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'ejs');

// uncomment after placing your favicon in /public
//app.use(favicon(path.join(__dirname, 'public', 'favicon.ico')));
app.use(logger('dev'));
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: false }));
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));

app.use('/', index);

// catch 404 and forward to error handler
app.use(function(req, res, next) {
  var err = new Error('Not Found');
  err.status = 404;
  next(err);
});

// error handler
app.use(function(err, req, res, next) {
  // set locals, only providing error in development
  res.locals.message = err.message;
  res.locals.error = req.app.get('env') === 'development' ? err : {};

  // render the error page
  res.status(err.status || 500);
  res.render('error');
});

// 日期format
app.locals.dateFormat = function (date) {
    console.log(date);
    return moment(date).format('YYYY-MM-DD HH:mm:ss').toString();
};


// 开启80端口
app.listen(80, '0.0.0.0');

console.log('http://127.0.0.1/');

module.exports = app;
